Select Contacts.*, Contacts.ID as CID from Contacts left join website_Data on Contacts.ID = website_Data.ContactID where CONCAT(Contacts.FirstName,' ', Contacts.LastName) LIKE '%Illusion Softwares%' order by Contacts.`Created` DESC